package com.b511.swpu.cementbackend.entity;

import com.fasterxml.jackson.annotation.JsonIgnore;
import lombok.Getter;
import lombok.Setter;
import lombok.experimental.Accessors;
import org.hibernate.annotations.GenericGenerator;
import org.hibernate.validator.constraints.Range;

import javax.persistence.*;

@Entity
@Getter
@Setter
@Accessors(chain = true)
// 扶正器安放位置设计 对应表 CM_CENTRALIZER_DESIGN
public class CM_CentralizerDesign extends BABaseEntity {
    @Id
    @GenericGenerator(name="centralizerDesignGenerator", strategy="uuid")
    @GeneratedValue(generator="centralizerDesignGenerator")
    private String CM_CentralizerDesign_ID;

    @Basic
    @Column(name = "CASINGSIZE")
    private Double casingSize;

    @Basic
    @Column(name = "BOTTOMDEPTH")
    private Double bottomDepth;

    @Basic
    @Column(name = "TOPDEPTH")
    private Double topDepth;

    @Basic
    @Column(name = "TYPE", length = 50)
    private String type;

    @Basic
    @Column(name = "MODEL", length = 50)
    private String model;

    @Basic
    @Column(name = "OUTERDIAMETER")
    private Double outerDiameter;

    @Basic
    @Column(name = "OUTERZIPDIAMETER")
    private Double outerZipDiameter;

    @Basic
    @Column(name = "TRIPPINGFORCE")
    private Double trippingForce;

    @Basic
    @Column(name = "RESISTANCE")
    private Double resistance;

    @Basic
    @Column(name = "RESILIENCE")
    private Double resilience;

    @Basic
    @Column(name = "METHOD", length = 50)
    private String method;

    // Number与Oracle的字段冲突 改为amount
    @Basic
    @Column(name = "AMOUNT")
    private Double amount;

    @Basic
    @Column(name = "BA_WELL_ID")
    @JsonIgnore
    private Long ba_well_id;

    @ManyToOne
    @JoinColumn(name="cm_basic_id")
    private CM_Basic basic;


}
